Spreadsheet for Soccer

[fhmesq44]

for those interested, attached is a spreadsheet that has a few handy formulas for the upcoming soccer season

Rows 1-6 figure out if there is a scalp on a particular game and determine the amount to RISK on each of the three lines to give you an equal outcome under all scenarios

• input the lines in the 3 green cells.
• If the blue cell is less than $100, you have a scalp
• Input the maximum amount you want to RISK on the most expensive play in the yellow cell
• RISK the amounts in the purple cells
• your net win is in the tan cell

Rows 13-20 make a +.5 line for you by playing both the team you want and the draw

• input the lines in the 3 green cells. If the team you want to play is negative (i.e, -120), make them Line A, if the team you want to play is positive (i.e., +120), make them Line B.
• input the total amount you want to RISK in the yellow cell
• If the team you want to play is negative (i.e., -120), RISK the amounts in the purple cells
• If the team you want to play is positive (i.e., +120), RISK the amounts in the blue cells
• Your net win is in tan under the appropriate blue or purple play

Rows 24-39 are to make a -1 line by playing your team -1.5 and to win

• Insert the money line in the green cell
• insert the -1.5 line in the yellow cell
• If you want to WIN in a fixed amount, insert that amount in the blue cell and RISK the amounts noted in the purple cells.
• if you want to RISK a fixed amount, insert that amount in the tan cell and RISK the amount in the pink cells.View attachment Plays II (10155517).XLS

 

[jdigae01]

hey man this is exceptional . i will take a look tonite. great job and thank u for sharing this. lets make some fukin money on soccer this year fellas.

 

[MrCleo]

great work

 

[joeyfitzclick]

Very, very impressive.

 

[fhmesq44]

Thanks

Just an FYI, it appears the +.5 line given by the books would be significantly better than that which you can make. So, you would probably only make your own line if one isn't provided by the book.

Eg, in tomorrows NYRB/Chivas game the lines are

<table class="module" rgfloat="440,600" border="0" bordercolor="#111111" cellpadding="0" cellspacing="0" width="800"><tbody><tr style="height: 28px;" bgcolor="#f6f6f6" valign="bottom"><td nowrap="nowrap">Thu 7/26</td><td nowrap="nowrap">517 </td><td nowrap="nowrap">Chivas USA (MLS)</td><td nowrap="nowrap"><input id="radiox" value="S1_0" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">+½ -119 </td><td nowrap="nowrap"><input id="radiox" value="M1_0" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">+285 </td><td nowrap="nowrap"><input id="radiox" value="L1_0" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">Over 2½ -105 </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td></tr><tr bgcolor="#f6f6f6" valign="middle"><td nowrap="nowrap">7:00PM (EST) </td><td nowrap="nowrap">518</td><td nowrap="nowrap">New York Red Bulls (MLS)</td><td nowrap="nowrap"><input id="radiox" value="S2_0" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">-½ -111 </td><td nowrap="nowrap"><input id="radiox" value="M2_0" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">-111 </td><td nowrap="nowrap"><input id="radiox" value="L2_0" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">Under 2½ -115 </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td></tr><tr style="height: 28px;" bgcolor="#f6f6f6" valign="top"><td nowrap="nowrap"> </td><td nowrap="nowrap">519</td><td nowrap="nowrap"> - Draw</td><td nowrap="nowrap"> </td><td nowrap="nowrap"><input id="radiox" value="M3_0" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">+230 </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td></tr><tr style="height: 28px;" bgcolor="#f6f6f6" valign="bottom"><td nowrap="nowrap">Thu 7/26</td><td nowrap="nowrap">517 </td><td nowrap="nowrap">Chivas USA (MLS)</td><td nowrap="nowrap"><input id="radiox" value="S1_1" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">-½ +285 </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td></tr><tr style="height: 28px;" bgcolor="#f6f6f6" valign="top"><td nowrap="nowrap">7:00PM (EST) </td><td nowrap="nowrap">518</td><td nowrap="nowrap">New York Red Bulls (MLS)</td><td nowrap="nowrap"><input id="radiox" value="S2_1" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">+½ -375 </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td></tr><tr style="height: 28px;" bgcolor="#f6f6f6" valign="bottom"><td nowrap="nowrap">Thu 7/26</td><td nowrap="nowrap">517 </td><td nowrap="nowrap">Chivas USA (MLS)</td><td nowrap="nowrap"><input id="radiox" value="S1_2" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">pk +181 </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td><td nowrap="nowrap"> </td></tr><tr style="height: 28px;" bgcolor="#f6f6f6" valign="top"><td nowrap="nowrap">7:00PM (EST) </td><td nowrap="nowrap">518</td><td nowrap="nowrap">New York Red Bulls (MLS)</td><td nowrap="nowrap"><input id="radiox" value="S2_2" name="radiox" language="javascript" onclick="return OnButtonClick()" type="radio">pk -241 </td><td nowrap="nowrap"> </td></tr></tbody></table>
Making your own lines would give you

Chivas +.5 -128
NYRB +.5 -485

 

[rhinooooo]

Nice work bro. Much appreciated.

 

[themadactuarian]

Drop your email here, will respond ASAP (as time permits, of course.)

Minor items.

MA

 

[fhmesq44]

first 6 letters of username at yahoo dot com

 

[jdigae01]

did you guys make edits to the sheet??

 

[fhmesq44]

I haven't, MA says he has a couple but hasn't emailed me yet.

 

[jdigae01]

ok ok good deal. im hoping to take an in depth look at it tonite or tomorrow.

 

[fhmesq44]

One last instruction, in the scalp spreadsheet, Line A always has to be the lowest odds.

 

[quantumleap]

Thanks fhm.

:thumbsup: